﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'parametrosBodegaUpdate')
	BEGIN
		DROP  Procedure  parametrosBodegaUpdate
	END
GO

CREATE PROCEDURE [dbo].[parametrosBodegaUpdate] 	
	(	
		@empresa_id AS INT,
		@sucursal_id AS INT,
		@bodega_materia_prima AS INT,
		@bodega_producto_proceso AS INT,
		@bodega_producto_terminado AS INT
	)	
AS
BEGIN	
	SET NOCOUNT ON
	
	UPDATE Lit_ParametrosBodega 
	SET BodegaMateriaPrima = @bodega_materia_prima,
		BodegaProductoEnProceso = @bodega_producto_proceso,
		BodegaProductoTerminado = @bodega_producto_terminado
	WHERE EmpresaId = @empresa_id
	AND SucursalId = @sucursal_id  
		
	SET NOCOUNT OFF
END
GO 